In this video we are going to discuss the INDIRECT function the INDIRECT function is used to return
a valid reference from a given text string.
What this means is it takes in one input that input is a string.
For example D4 is a text or day.
Here is a text.
Such text goes as input in the INDIRECT function.
It considers this text as an address and points us to that address.
You can also consider this as hyper linking that particular value let us look at an example to understand
it more clearly in this seven cell.
I have a text which is default before text can also be considered as the address to this particular
cell which contains the value vegetables in front of the cell.
If I want to get the content of the deeper say how do I do it.
One way is I simply that is equal to before
which gives me vegetables.
But if I update before to eat for
this it is not dynamically updated to make this cell dynamically updated.
We will use the INDIRECT function to what we Lewis will write in Derek
and I will select this cell which contains the name of it
now.
Whenever I see value in this I'll say it for.
It will automatically update because this INDIRECT function will now point to F4 instead of equal.
So basically whatever it takes we have in this in that text is converted to an address and whatever
we have in that address is shown here.
With an Indirect function we can also pass the assigned name that is the name range or cell names that
we have given so for example I have created few names such as these so the day name is given to this
particular cell.
Baby Name is given to this range of cell similarly milk vegetables meat and all of these columns have
their respective names.
Now these are assigned names or the names that I have given can also be used to reference in the INDIRECT
function.
So if I use it is equal to indirect and within brackets I give this name.
This will point to the cell which has the name date for this cell which is Monday.
It has the name date so the indented contender done does the name Monday so you can see here date was
just a text but INDIRECT function converted this text into the address of that particular seed from
which we want to do redundant contains we can do the same thing with named ranges.
You can see here I have in text format the range defined to be 21.
So if I want to sum all the contents of B5 to be 21 I can simply use the INDIRECT function really first
rate some
then indirect
and then specify this B5 to be 21
and this gives us these some of all the values from B5 to be 21 similarly instead of giving these range
from as defined to be 21 we can use the assigned name that is vegetables for this entire range so we
can also write is equal to some
embedded and this name
the real benefit of using embedded function here is that we get a dynamic sheet whenever we update the
value in this field see if we put milk it will automatically give us these sum of values in the range
of choices which are titled milk
if I do DVD it will automatically update and give us the sum of all the duties is in our table.
So this is how we use INDIRECT function in that it function will help us make our seed dynamic every
location we want to point to we can have that name here whenever we update that location the output
will be automatically updated.